Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
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)"]
View Answer
A
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" ]
View Answer
A
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
View Answer
D
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)"]
View Answer
B
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)"]
View Answer
A
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
View Answer
A
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
View Answer
B
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
View Answer
A
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
View Answer
A
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
View Answer
B