MICROCOMPUTER APPS EXCEL EXAM
QUESTIONS AND ANSWERS
.xlsx - Correct Answers -By default, what file name extension is given to Excel workbook
files?
bottom left of a cell - Correct Answers -By default, how does Excel align labels in a cell?
bottom right of a cell - Correct Answers -By default, how does Excel align values in a
cell?
Status bar - Correct Answers -In the Excel window, which of the following continuously
displays the buttons for switching worksheet views?
all worksheet cells - Correct Answers -What is selected when you click the Select All
button located above the row 1 heading and to the left of the column A heading?
the entire column - Correct Answers -What is selected when you point to and click a
column heading?
Ctrl - Correct Answers -What key do you press to select non-adjacent worksheets?
Shift - Correct Answers -What key do you press to select adjacent worksheets?
F4 - Correct Answers -Once you have selected a cell address, which of the following
keys lets you insert dollar signs quickly?
trendline - Correct Answers -Which of the following is a chart element that plots patterns
using a moving average of the current data?
chart style - Correct Answers -Which of the following is a preset combination of colors
and effects for a chart, its background, and its elements?
Esc - Correct Answers -Which of the following cancels a formula before it is completed?
= - Correct Answers -Which of the following characters always starts a formula?
= E4 + E5 - Correct Answers -Which of the following formulas correctly adds the values
in cells E4 and E5?
PMT - Correct Answers -Which of the following functions calculates a constant loan
payment amount for a period of time at a stated interest rate?
QUESTIONS AND ANSWERS
.xlsx - Correct Answers -By default, what file name extension is given to Excel workbook
files?
bottom left of a cell - Correct Answers -By default, how does Excel align labels in a cell?
bottom right of a cell - Correct Answers -By default, how does Excel align values in a
cell?
Status bar - Correct Answers -In the Excel window, which of the following continuously
displays the buttons for switching worksheet views?
all worksheet cells - Correct Answers -What is selected when you click the Select All
button located above the row 1 heading and to the left of the column A heading?
the entire column - Correct Answers -What is selected when you point to and click a
column heading?
Ctrl - Correct Answers -What key do you press to select non-adjacent worksheets?
Shift - Correct Answers -What key do you press to select adjacent worksheets?
F4 - Correct Answers -Once you have selected a cell address, which of the following
keys lets you insert dollar signs quickly?
trendline - Correct Answers -Which of the following is a chart element that plots patterns
using a moving average of the current data?
chart style - Correct Answers -Which of the following is a preset combination of colors
and effects for a chart, its background, and its elements?
Esc - Correct Answers -Which of the following cancels a formula before it is completed?
= - Correct Answers -Which of the following characters always starts a formula?
= E4 + E5 - Correct Answers -Which of the following formulas correctly adds the values
in cells E4 and E5?
PMT - Correct Answers -Which of the following functions calculates a constant loan
payment amount for a period of time at a stated interest rate?
