CA Foundation Business Economics Questions 2023 - Part 32
Fri, 03 Mar 2023
Inspirational journeys
Follow the stories of academics and their research expeditions
Excel Certification Success Practice Questions 2023 - Part 2
1. Which of the following is NOT a valid way to enter data into an Excel cell?
A) Typing directly into the cell
B) Copying and pasting from another cell
C) Importing from a PDF file
D) Dragging and dropping from another cell
2. Which of the following formats cannot be applied to a cell in Excel?
A) Currency
B) Date
C) Percentage
D) Sound
3. Which of the following functions can be used to round up a number to the nearest whole number?
A) ROUND
B) ROUNDDOWN
C) ROUNDUP
D) CEILING
4. What is the result of the formula =ROUND(3.14159, 2) in Excel?
A) 3.15
B) 3.16
C) 3.1
D) 3.14
5. What is the shortcut key to insert a new worksheet in Excel?
A) Shift+F11
B) Alt + N
C) Alt + Shift + N
D) Ctrl + N
A) Typing directly into the cell
B) Copying and pasting from another cell
C) Importing from a PDF file
D) Dragging and dropping from another cell
2. Which of the following formats cannot be applied to a cell in Excel?
A) Currency
B) Date
C) Percentage
D) Sound
3. Which of the following functions can be used to round up a number to the nearest whole number?
A) ROUND
B) ROUNDDOWN
C) ROUNDUP
D) CEILING
4. What is the result of the formula =ROUND(3.14159, 2) in Excel?
A) 3.15
B) 3.16
C) 3.1
D) 3.14
5. What is the shortcut key to insert a new worksheet in Excel?
A) Shift+F11
B) Alt + N
C) Alt + Shift + N
D) Ctrl + N
1. Right Answer: D
Explanation: Importing data from a PDF file is not a valid way to enter data into an Excel cell.
2. Right Answer: D
Explanation: Sound is not a valid format in Excel.
3. Right Answer: C
Explanation: The ROUNDUP function can be used to round up a number to the nearest whole number.
4. Right Answer: D
Explanation: The ROUND function rounds a number to a specified number of digits. Therefore, the formula calculates as ROUND(3.14159, 2) = 3.14.
5. Right Answer: A
Explanation: The shortcut key to insert a new worksheet in Excel is Shift + F11.
Explanation: Importing data from a PDF file is not a valid way to enter data into an Excel cell.
2. Right Answer: D
Explanation: Sound is not a valid format in Excel.
3. Right Answer: C
Explanation: The ROUNDUP function can be used to round up a number to the nearest whole number.
4. Right Answer: D
Explanation: The ROUND function rounds a number to a specified number of digits. Therefore, the formula calculates as ROUND(3.14159, 2) = 3.14.
5. Right Answer: A
Explanation: The shortcut key to insert a new worksheet in Excel is Shift + F11.
Tags:
mark education school exam excellent success paper test result study grade student good knowledge happy best young flat girl college university vector score cheerful learning illustration homework smart child boy people background teenager smile pupil character cartoon choice perfect isolated form concept kid showing examination successful sheet questionnaire childhood document0 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