CA Foundation Business Economics Questions 2023 - Part 32
Fri, 03 Mar 2023
Inspirational journeys
Follow the stories of academics and their research expeditions
PracticeTests for Excel - Part 1
1. What is the shortcut key to insert the current date in Excel?
A) Ctrl + ;
B) Alt + ;
C) Alt + Shift + ;
D) Ctrl + Shift + ;
2. What is the result of the formula =5+2*3 in Excel?
A) 29
B) 15
C) 11
D) 21
3. Which of the following is NOT a part of the Excel interface?
A) Quick Access Toolbar
B) Taskbar
C) Ribbon
D) Status Bar
4. Which of the following is NOT a valid function in Excel?
A) SUM
B) PRODUCT
C) AVERAGE
D) INCREMENT
5. What is the keyboard shortcut to apply the bold formatting to selected text in Excel?
A) Alt + B
B) F11
C) Ctrl + B
D) Shift + B
A) Ctrl + ;
B) Alt + ;
C) Alt + Shift + ;
D) Ctrl + Shift + ;
2. What is the result of the formula =5+2*3 in Excel?
A) 29
B) 15
C) 11
D) 21
3. Which of the following is NOT a part of the Excel interface?
A) Quick Access Toolbar
B) Taskbar
C) Ribbon
D) Status Bar
4. Which of the following is NOT a valid function in Excel?
A) SUM
B) PRODUCT
C) AVERAGE
D) INCREMENT
5. What is the keyboard shortcut to apply the bold formatting to selected text in Excel?
A) Alt + B
B) F11
C) Ctrl + B
D) Shift + B
1. Right Answer: A
Explanation: The shortcut key to insert the current date in Excel is Ctrl + ;.
2. Right Answer: C
Explanation: The order of operations in Excel is multiplication and division before addition and subtraction. Therefore, the formula calculates as 5 + (2*3) = 11.
3. Right Answer: B
Explanation: The Taskbar is a part of the Windows operating system and not a part of the Excel interface.
4. Right Answer: D
Explanation: INCREMENT is not a valid function in Excel.
5. Right Answer: C
Explanation: The keyboard shortcut to apply the bold formatting to selected text in Excel is Ctrl + B.
Explanation: The shortcut key to insert the current date in Excel is Ctrl + ;.
2. Right Answer: C
Explanation: The order of operations in Excel is multiplication and division before addition and subtraction. Therefore, the formula calculates as 5 + (2*3) = 11.
3. Right Answer: B
Explanation: The Taskbar is a part of the Windows operating system and not a part of the Excel interface.
4. Right Answer: D
Explanation: INCREMENT is not a valid function in Excel.
5. Right Answer: C
Explanation: The keyboard shortcut to apply the bold formatting to selected text in Excel is Ctrl + B.
0 Comments
Categories
Recent posts
CA Foundation Business Economics Questions 2023 - Part 31
Fri, 03 Mar 2023
CA Foundation Business Economics Questions 2023 - Part 30
Fri, 03 Mar 2023
Leave a comment