TOSA REMOTE PROCTORED Practice Exam
**Question 1.** Which ribbon tab contains the “Insert Worksheet” command?
A) Home
B) Insert
C) Page Layout
D) Formulas
Answer: B
Explanation: The Insert tab provides the “Insert Worksheet” button for adding new sheets.
**Question 2.** In Excel, which shortcut opens the Format Cells dialog box?
A) Ctrl + 1
B) Ctrl + Shift + F
C) Alt + E, then S
D) Alt + H, then O
Answer: A
Explanation: Ctrl + 1 instantly opens the Format Cells window for the selected range.
**Question 3.** What does the Quick Access Toolbar (QAT) allow users to do?
A) Change the default workbook theme
B) Add frequently used commands for easy access
C) Display hidden rows and columns
D) Switch between Normal and Page Layout view
Answer: B
Explanation: The QAT is a customizable toolbar where users can pin commands they use often.
**Question 4.** Which of the following functions returns the smallest numeric value in a
range?
, TOSA REMOTE PROCTORED Practice Exam
A) MIN
B) SMALL
C) LOWEST
D) MINIMUM
Answer: A
Explanation: MIN directly returns the smallest number; SMALL returns the nth smallest.
**Question 5.** When you want to sum only the values that meet a specific criterion, which
function should you use?
A) SUMIF
B) SUMIFS
C) SUMPRODUCT
D) COUNTIF
Answer: A
Explanation: SUMIF adds numbers that satisfy a single condition; SUMIFS handles multiple
conditions.
**Question 6.** In a VLOOKUP formula, what does the fourth argument (range_lookup)
control?
A) The column index number
B) Whether the lookup is exact or approximate
C) The worksheet to search in
D) The type of data to return
Answer: B
Explanation: Setting range_lookup to FALSE forces an exact match; TRUE allows approximate
matches.
, TOSA REMOTE PROCTORED Practice Exam
**Question 7.** Which function can be used to count the number of cells that contain numbers
in a range?
A) COUNTA
B) COUNT
C) COUNTBLANK
D) COUNTIF
Answer: B
Explanation: COUNT counts only numeric entries, while COUNTA counts all non‑blank cells.
**Question 8.** What does the “Page Break Preview” view display?
A) A grid of all worksheets in the workbook
B) The layout of printed pages with page breaks shown
C) A preview of how charts will look when printed
D) A collapsed view of hidden rows and columns
Answer: B
Explanation: Page Break Preview shows where Excel will insert page breaks when printing.
**Question 9.** Which of the following is NOT a valid way to protect a worksheet?
A) Adding a password to modify the sheet
B) Hiding all formulas
C) Using the “Allow Users to Edit Ranges” feature without a password
D) Locking cells and protecting the sheet
Answer: C
Explanation: Allowing users to edit ranges without a password does not protect the sheet.
**Question 10.** Which command removes duplicate rows from a selected range?
, TOSA REMOTE PROCTORED Practice Exam
A) Data → Sort
B) Data → Remove Duplicates
C) Home → Clear → All
D) Review → Protect Sheet
Answer: B
Explanation: The Remove Duplicates tool finds and deletes duplicate records in a range.
**Question 11.** In PowerPoint, which view allows you to edit the overall design of the
presentation?
A) Normal view
B) Slide Master view
C) Reading view
D) Slide Sorter view
Answer: B
Explanation: Slide Master view lets you modify layouts, fonts, and placeholders for the entire
deck.
**Question 12.** Which file format preserves animations and transitions when sharing a
PowerPoint presentation?
A) PDF
B) PPTX
C) PPT
D) ODP
Answer: B
Explanation: PPTX (the default Office Open XML format) retains all multimedia, animation, and
transition data.
**Question 1.** Which ribbon tab contains the “Insert Worksheet” command?
A) Home
B) Insert
C) Page Layout
D) Formulas
Answer: B
Explanation: The Insert tab provides the “Insert Worksheet” button for adding new sheets.
**Question 2.** In Excel, which shortcut opens the Format Cells dialog box?
A) Ctrl + 1
B) Ctrl + Shift + F
C) Alt + E, then S
D) Alt + H, then O
Answer: A
Explanation: Ctrl + 1 instantly opens the Format Cells window for the selected range.
**Question 3.** What does the Quick Access Toolbar (QAT) allow users to do?
A) Change the default workbook theme
B) Add frequently used commands for easy access
C) Display hidden rows and columns
D) Switch between Normal and Page Layout view
Answer: B
Explanation: The QAT is a customizable toolbar where users can pin commands they use often.
**Question 4.** Which of the following functions returns the smallest numeric value in a
range?
, TOSA REMOTE PROCTORED Practice Exam
A) MIN
B) SMALL
C) LOWEST
D) MINIMUM
Answer: A
Explanation: MIN directly returns the smallest number; SMALL returns the nth smallest.
**Question 5.** When you want to sum only the values that meet a specific criterion, which
function should you use?
A) SUMIF
B) SUMIFS
C) SUMPRODUCT
D) COUNTIF
Answer: A
Explanation: SUMIF adds numbers that satisfy a single condition; SUMIFS handles multiple
conditions.
**Question 6.** In a VLOOKUP formula, what does the fourth argument (range_lookup)
control?
A) The column index number
B) Whether the lookup is exact or approximate
C) The worksheet to search in
D) The type of data to return
Answer: B
Explanation: Setting range_lookup to FALSE forces an exact match; TRUE allows approximate
matches.
, TOSA REMOTE PROCTORED Practice Exam
**Question 7.** Which function can be used to count the number of cells that contain numbers
in a range?
A) COUNTA
B) COUNT
C) COUNTBLANK
D) COUNTIF
Answer: B
Explanation: COUNT counts only numeric entries, while COUNTA counts all non‑blank cells.
**Question 8.** What does the “Page Break Preview” view display?
A) A grid of all worksheets in the workbook
B) The layout of printed pages with page breaks shown
C) A preview of how charts will look when printed
D) A collapsed view of hidden rows and columns
Answer: B
Explanation: Page Break Preview shows where Excel will insert page breaks when printing.
**Question 9.** Which of the following is NOT a valid way to protect a worksheet?
A) Adding a password to modify the sheet
B) Hiding all formulas
C) Using the “Allow Users to Edit Ranges” feature without a password
D) Locking cells and protecting the sheet
Answer: C
Explanation: Allowing users to edit ranges without a password does not protect the sheet.
**Question 10.** Which command removes duplicate rows from a selected range?
, TOSA REMOTE PROCTORED Practice Exam
A) Data → Sort
B) Data → Remove Duplicates
C) Home → Clear → All
D) Review → Protect Sheet
Answer: B
Explanation: The Remove Duplicates tool finds and deletes duplicate records in a range.
**Question 11.** In PowerPoint, which view allows you to edit the overall design of the
presentation?
A) Normal view
B) Slide Master view
C) Reading view
D) Slide Sorter view
Answer: B
Explanation: Slide Master view lets you modify layouts, fonts, and placeholders for the entire
deck.
**Question 12.** Which file format preserves animations and transitions when sharing a
PowerPoint presentation?
A) PDF
B) PPTX
C) PPT
D) ODP
Answer: B
Explanation: PPTX (the default Office Open XML format) retains all multimedia, animation, and
transition data.
