-
web.groovymark@gmail.com
- December 8, 2024
Question 41
What is the path to the ‘Protect Sheet’ button in Excel?
A. REVIEW tab
B. HOME tab
C. INSERT tab
D. VIEW tab
Answer: A. REVIEW tab
Explanation: The Protect Sheet button is located in the REVIEW tab under the Changes group.
Question 42
How do you hide a worksheet in Excel?
A. Click Hide in the shortcut menu
B. Use the Insert menu
C. Click Remove Worksheet in the tab options
D. Delete the worksheet
Answer: A. Click Hide in the shortcut menu
Explanation: You can hide a worksheet by right-clicking its tab and selecting Hide.
Question 43
What is a reference to a cell or range of cells in another workbook called?
A. External reference
B. Named range
C. Data link
D. External cell
Answer: A. External reference
Explanation: An external reference refers to a cell or range of cells in another workbook.
Question 44
Which function is used when a table is organized horizontally in Excel?
A. VLOOKUP
B. HLOOKUP
C. INDEX
D. MATCH
Answer: B. HLOOKUP
Explanation: HLOOKUP is used to search for values in tables organized horizontally.
Question 45
Which function is most commonly used in vertical tables?
A. HLOOKUP
B. INDEX
C. MATCH
D. VLOOKUP
Answer: D. VLOOKUP
Explanation: VLOOKUP is most commonly used to search for values in tables organized vertically.
Question 46
What type of formatting allows you to apply rules based on cell values?
A. Table formatting
B. Conditional formatting
C. Data validation
D. Rule formatting
Answer: B. Conditional formatting
Explanation: Conditional formatting applies rules to cells based on their values, changing the cell’s appearance if conditions are met.
Question 47
What do you call the left column values in a table array used for VLOOKUP?
A. Table headers
B. Table fields
C. Table arguments
D. Lookup values
Answer: D. Lookup values
Explanation: The left column values used in a table array for VLOOKUP are called lookup values.
Question 48
What is the path to the ‘Total Row’ check box for tables?
A. TABLE TOOLS DESIGN tab
B. HOME tab
C. INSERT tab
D. PAGE LAYOUT tab
Answer: A. TABLE TOOLS DESIGN tab
Explanation: The Total Row check box is found in the TABLE TOOLS DESIGN tab under the Table Style Options group.
Question 49
How is data arranged when it is in ascending sequence?
A. Highest to lowest
B. A-Z
C. Z-A
D. By size
Answer: B. A-Z
Explanation: Data is in ascending order when arranged alphabetically from A to Z or numerically from smallest to largest.
Question 50
What is the path to the Format Painter button in Excel?
A. HOME tab
B. INSERT tab
C. DATA tab
D. VIEW tab
Answer: A. HOME tab
Explanation: The Format Painter button is located in the HOME tab under the Clipboard group.
