©BRAINBARTER 2024/2025
Comprehensive Spreadsheets Exam
Questions With Verified Answers
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.
- answer✔T
You can use the DELETE key to clear cell contents - answer✔T
To print worksheet contents across the length of a page, you can use portrait orientation. -
answer✔F
When you enter a value in a worksheet cell, it is automatically left-aligned. - answer✔F
You can use the I-beam pointer to copy cell contents into adjacent cells. - answer✔F
To print a worksheet, you begin by going to Backstage view. - answer✔T
To fit all worksheet content on one page, you can set page scaling in Backstage view. -
answer✔T
You can edit cell contents in the Formula bar or in the cell itself. - answer✔T
To enter a typed number into a cell, you can press Tab or Backspace. - answer✔F
When you copy and paste a formula with absolute cell references, Excel substitutes new
references to reflect the new formula location. - answer✔F
To find the largest value in a cell range, use the MIN function. - answer✔F
The easiest way to insert the SUM function is to use the AutoSum button on the Home tab. -
answer✔T
You have selected a cell with a formula. Which of the following can you use to copy that
formula to an adjacent cell? - answer✔Fill handle
In the formula =SUM(A6:A9), which of the following best describes A6? - answer✔argument
What lets you edit the contents of a cell? - answer✔Double-click the cell or click in the formula
bar.
, ©BRAINBARTER 2024/2025
Where can you see a preview of how your worksheet will look when printed, including headers?
- answer✔Print tab in Backstage view
What formulas totals the cells B6, B7, B8, B9, and B10 most efficiently? - answer✔The formula
=SUM(B6:B10)
To have Excel enter the lowest price from a range of prices, which of the following would you
use? - answer✔MIN function
What tabs lets you see exactly how your worksheet looks before printing? - answer✔File
To see a preview of how a pasted value will look, which of the following would you use? -
answer✔Paste List arrow
Which of the following functions would you use to calculate the arithmetic mean of a price list? -
answer✔AVERAGE
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you
use? - answer✔Page Layout
To print more than one copy of your worksheet, which tab would you go to? - answer✔File
If you discover an error immediately after you have confirmed a cell entry, what would you use
next? - answer✔The Undo button on the Quick Access toolbar
To select a single worksheet cell so you can work with it, which of the following would you do?
- answer✔Click the cell
Which of the following functions inserts the total of a range? - answer✔SUM
How many actions does the Undo button let you reverse? - answer✔100
Which of the following would you use to create a duplicate of the selected cell when the CTRL
key is pressed? - answer✔Copy pointer
Which of the following lets you search for a function or select one from a category? -
answer✔Insert Function dialog box
Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?
- answer✔Change the page orientation to landscape
What tab lets you set worksheet print options? - answer✔File
To print your worksheet at its actual size, which of the following would you select? -
answer✔No scaling
Comprehensive Spreadsheets Exam
Questions With Verified Answers
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.
- answer✔T
You can use the DELETE key to clear cell contents - answer✔T
To print worksheet contents across the length of a page, you can use portrait orientation. -
answer✔F
When you enter a value in a worksheet cell, it is automatically left-aligned. - answer✔F
You can use the I-beam pointer to copy cell contents into adjacent cells. - answer✔F
To print a worksheet, you begin by going to Backstage view. - answer✔T
To fit all worksheet content on one page, you can set page scaling in Backstage view. -
answer✔T
You can edit cell contents in the Formula bar or in the cell itself. - answer✔T
To enter a typed number into a cell, you can press Tab or Backspace. - answer✔F
When you copy and paste a formula with absolute cell references, Excel substitutes new
references to reflect the new formula location. - answer✔F
To find the largest value in a cell range, use the MIN function. - answer✔F
The easiest way to insert the SUM function is to use the AutoSum button on the Home tab. -
answer✔T
You have selected a cell with a formula. Which of the following can you use to copy that
formula to an adjacent cell? - answer✔Fill handle
In the formula =SUM(A6:A9), which of the following best describes A6? - answer✔argument
What lets you edit the contents of a cell? - answer✔Double-click the cell or click in the formula
bar.
, ©BRAINBARTER 2024/2025
Where can you see a preview of how your worksheet will look when printed, including headers?
- answer✔Print tab in Backstage view
What formulas totals the cells B6, B7, B8, B9, and B10 most efficiently? - answer✔The formula
=SUM(B6:B10)
To have Excel enter the lowest price from a range of prices, which of the following would you
use? - answer✔MIN function
What tabs lets you see exactly how your worksheet looks before printing? - answer✔File
To see a preview of how a pasted value will look, which of the following would you use? -
answer✔Paste List arrow
Which of the following functions would you use to calculate the arithmetic mean of a price list? -
answer✔AVERAGE
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you
use? - answer✔Page Layout
To print more than one copy of your worksheet, which tab would you go to? - answer✔File
If you discover an error immediately after you have confirmed a cell entry, what would you use
next? - answer✔The Undo button on the Quick Access toolbar
To select a single worksheet cell so you can work with it, which of the following would you do?
- answer✔Click the cell
Which of the following functions inserts the total of a range? - answer✔SUM
How many actions does the Undo button let you reverse? - answer✔100
Which of the following would you use to create a duplicate of the selected cell when the CTRL
key is pressed? - answer✔Copy pointer
Which of the following lets you search for a function or select one from a category? -
answer✔Insert Function dialog box
Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?
- answer✔Change the page orientation to landscape
What tab lets you set worksheet print options? - answer✔File
To print your worksheet at its actual size, which of the following would you select? -
answer✔No scaling
