Table of Contents
- 1 What feature could be used to print a very long worksheet on a single sheet of paper?
- 2 Where can you see a preview of how your worksheet will look when printed?
- 3 What type of cell reference is C $19 *?
- 4 What is the maximum number of worksheets you can include in a workbook in Excel?
- 5 How do you set the maximum row height in Excel?
- 6 What feature inserts a function that totals the cells above or to the left of the selected cell quizlet?
What feature could be used to print a very long worksheet on a single sheet of paper?
Cards
| Term Formula prefix | Definition Equal sign preceding a formula |
|---|---|
| Term Cell reference | Definition Using a cell address in a formula is known as: |
| Term Scale to Fit | Definition Which feature could be used to print a very long worksheet on a single sheet of paper? |
| Term Range | Definition A selection of multiple cells is called a: |
Where can you see a preview of how your worksheet will look when printed?
When you select one or more sheets and then click File > Print, you’ll see a preview of how the data will appear on the printout. Select the worksheet(s) you want to preview.
Which of the following features resizes column width or row height to fit the width or height of the longest or tallest entry?
Excel- resizes column width or row height to accommodate the width or height or the largest entry. Excel- combines two or more cells into one cell and centers the text.
What feature inserts a function that totals the cells above or to the left of the selected cell?
The quickest way to sum a range of cells is to use the AutoSum button. It automatically enters a SUM function in the selected cell. The SUM function totals one or more numbers in a range of cells. Select the blank cell in the row below the cells that you want to sum, cell A5 in this example.
What type of cell reference is C $19 *?
What type of cell reference is C $19?
| Term Formula prefix | Definition Equal sign preceding a formula |
|---|---|
| Term [Ctrl] | Definition Which key doyou press to copy while dragging and dropping selected cells? |
| Term Mixed | Definition What type of reference is C$19? |
What is the maximum number of worksheets you can include in a workbook in Excel?
255 sheets
Although you’re limited to 255 sheets in a new workbook, Excel doesn’t limit how many worksheets you can add after you’ve created a workbook. The only factor that ultimately limits the number of worksheets your workbook can hold is your computer’s memory.
What is a print preview?
Print Preview is a functionality that lets users see the pages that are about to print, allowing the users to see exactly how the pages will look when they are printed.
How do I check print preview?
To open the print preview feature, click the print preview icon on the toolbar, like that shown in the picture, or click File and choose the Print Preview option. Some programs, like newer versions of Microsoft Office applications, show a print preview on the Print page.
How do you set the maximum row height in Excel?
Set a row to a specific height
- Select the row or rows that you want to change.
- On the Home tab, in the Cells group, click Format.
- Under Cell Size, click Row Height.
- In the Row height box, type the value that you want, and then click OK.
What feature inserts a function that totals the cells above or to the left of the selected cell quizlet?
Use AutoSum to enter a formula in the selected cell to calculate the total of all the contiguous cells above. In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the AutoSum button arrow. In the AutoSum menu, you clicked the Sum menu item. You pressed Enter.
Which function can find the highest value in a cell range?
The Excel MAX function returns the largest numeric value in a range of values.