Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Chapter: 222
Q3021:
Fill in the blank: The SUM formula can be copied to multiple cells using the ________ handle in Excel.
A. Selection
B. Copy-paste
C. Drag-and-drop
D. Fill
Correct Answer:
D
Chapter: 222
Q3022:
What is the result of applying the SUM formula to cells containing non-numeric data?
A. Error
B. Sum of values
C. Ignored
D. Formula adjusts
Correct Answer:
A
Chapter: 222
Q3023:
Fill in the blank: After applying the SUM formula, the resulting total can be seen in ________.
A. The formula bar
B. The original cells
C. The selected cell
D. The header
Correct Answer:
C
Chapter: 223
Q3024:
What is the formula to calculate the total expense for January month in Excel?
A. [ "=SUM(B3)" ]
B. [ "=AVERAGE(B3)" ]
C. [ "=SUM(B16)" ]
D. [ "=MAX(B3)" ]
Correct Answer:
A
Chapter: 223
Q3025:
Which formula is used to calculate the average expense for the Electricity Bill?
A. [ "=AVERAGE(B3)" ]
B. [ "=MAX(B3)" ]
C. [ "=SUM(B16)" ]
D. [ "=SUM(B3)" ]
Correct Answer:
A
Chapter: 223
Q3026:
How do you find the highest expense for the Electricity Bill in Excel?
A. ["=MIN(B3)"]
B. ["=MAX(B3)"]
C. ["=SUM(B16)"]
D. ["=AVERAGE(B3)"]
Correct Answer:
B
Chapter: 223
Q3027:
What formula will you use to find the minimum expense for the year 2020 in Excel?
A. [ "=MIN(B3)" ]
B. [ "=AVERAGE(B3)" ]
C. [ "=SUM(B16)" ]
D. ["=MAX(B3)"]
Correct Answer:
A
Chapter: 223
Q3028:
The formula =SUM(B16) calculates what in the personal expense sheet?
A. Total expense for the year 2020
B. Total expense for January month
C. Average expense for the year 2020
D. Maximum expense for the year 2020
Correct Answer:
A
Chapter: 223
Q3029:
In Excel, which function is used to find the sum of a range of cells?
A. [ "=SUM" ]
B. [ "=AVERAGE" ]
C. [ "=MIN" ]
D. [ "=MAX" ]
Correct Answer:
A
Chapter: 223
Q3030:
What does the formula =MAX(B3) return?
A. Maximum value in the range B3
B. Minimum value in the range B3
C. Sum of values in the range B3
D. Average of values in B3
Correct Answer:
A
Chapter: 223
Q3031:
Which formula would you use to calculate the total Electricity Bill expense in Excel?
A. [ "=SUM(B3)" ]
B. [ "=AVERAGE(B3)" ]
C. [ "=MIN(B3)" ]
D. ["=MAX(B3)"]
Correct Answer:
A
Chapter: 223
Q3032:
To find the average of a set of expenses in Excel, you would use which formula?
A. [ "=AVERAGE" ]
B. [ "=SUM" ]
C. [ "=MIN" ]
D. [ "=MAX" ]
Correct Answer:
A
Chapter: 223
Q3033:
Fill in the blank: The formula =MIN(B3) is used to find the ______ expense in the range.
A. maximum
B. total
C. average
D. minimum
Correct Answer:
D
Chapter: 223
Q3034:
Fill in the blank: The formula _______ calculates the total expense for the year 2020.
A. ["=MAX(B3)"]
B. [ "=SUM(B16)" ]
C. [ "=AVERAGE(B3)" ]
D. ["=MIN(B3)"]
Correct Answer:
B
Chapter: 223
Q3035:
Fill in the blank: The formula to find the total expense for January month is _______.
A. [ "=SUM(B3)" ]
B. [ "=AVERAGE(B3)" ]
C. [ "=SUM(B16)" ]
D. ["=MAX(B3)"]
Correct Answer:
A
Chapter: 224
Q3036:
What does Sorting and Filtering allow you to do in a worksheet?
A. Manipulate data
B. Create charts
C. Insert formulas
D. Format cells
Correct Answer:
A
Chapter: 224
Q3037:
What are the two types of sorts available in Microsoft Excel?
A. Basic Sort and Advanced Sort
B. Basic Sort and Custom Sort
C. Custom Sort and Advanced Sort
D. Automatic Sort and Manual Sort
Correct Answer:
B
Chapter: 224
Q3038:
Which button do you click on the Home tab to start sorting data in Excel?
A. Sort & Filter
B. Sort Data
C. Filter Data
D. Data Analysis
Correct Answer:
A
Chapter: 224
Q3039:
In a basic sort, which buttons can be used to sort data in ascending or descending order?
A. A-Z and Z-A
B. Sort Up and Sort Down
C. Ascend and Descend
D. A-Z and 1-9
Correct Answer:
A
Chapter: 224
Q3040:
What is the first step to execute a basic sort in Excel?
A. Click the Home tab
B. Highlight the cells to be sorted
C. Click the Data tab
D. Insert a formula
Correct Answer:
B