COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAM
LATEST 2024 ACTUAL EXAM
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.
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
Which of the following is the temporary Windows storage area that holds selections
you copy or cut? - ANSWER: Clipboard
LATEST 2024 ACTUAL EXAM
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.
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
Which of the following is the temporary Windows storage area that holds selections
you copy or cut? - ANSWER: Clipboard
