SIMNET Microsoft Excel
Proficiency Examination –
Official Software Proficiency
Certification Board
Exam Overview
The SIMNET Excel Proficiency Examination evaluates students' skills in Microsoft
Excel through performance-based simulations and multiple-choice questions . The
platform offers a progression of digital credentials from White Belt (Level 1) through
Black Belt (Level 4), with Advanced and Applied Expert credentials available .
Advanced credentials may require completing specific exams with a 90% or higher
score .
SECTION 1: ESSENTIAL SKILLS & FUNDAMENTALS
Question 1
Which of the following keystroke combinations completes a formula in Excel?
A) Shift+Enter
B) Ctrl+Enter
,C) Alt+Enter
D) Tab
Answer: B) Ctrl+Enter
Rationale: Ctrl+Enter completes a formula and keeps the active cell selected. This
is distinct from pressing Enter alone, which moves to the next cell down . The
Shift+F3 shortcut opens the Insert Function dialog box .
Question 2
Which of the following displays the result of a formula?
A) Formula bar
B) Cell
C) Name box
D) Status bar
Answer: B) Cell
Rationale: A cell displays the result of the formula, while the formula bar displays
the underlying formula itself . The Name box shows the cell address, and the Status
bar can show AutoCalculate results.
Question 3
The cell address $R$6 is an example of which type of cell reference?
A) Relative reference
B) Absolute reference
,C) Mixed reference
D) Named range
Answer: B) Absolute reference
Rationale: $R$6 is an absolute cell reference because the dollar sign
(
)𝑖𝑠𝑝𝑙𝑎𝑐𝑒𝑑𝑏𝑒𝑓𝑜𝑟𝑒𝑏𝑜𝑡ℎ𝑡ℎ𝑒𝑐𝑜𝑙𝑢𝑚𝑛𝑙𝑒𝑡𝑡𝑒𝑟𝑎𝑛𝑑𝑟𝑜𝑤𝑛𝑢𝑚𝑏𝑒𝑟. 𝑇ℎ𝑖𝑠𝑝𝑟𝑒𝑣𝑒𝑛𝑡𝑠𝑒𝑖𝑡ℎ𝑒𝑟𝑓𝑟𝑜𝑚𝑐ℎ𝑎𝑛𝑔𝑖𝑛
R6 would be mixed (absolute row, relative column), and R$6 would be mixed
(relative row, absolute column).
Question 4
Which of the following expressions equals 11?
A) 3+24
B) (3+2)4
C) 3+(2*4)
D) 3*2+4
Answer: A) 3+2*4
Rationale: According to the order of operations (PEMDAS), multiplication is
performed before addition. 24 = 8, then 3 + 8 = 11. Option B calculates (5)4 = 20,
Option C calculates 3+8 = 11 (also correct but not the best answer), and Option D
calculates 6+4 = 10. Excel follows standard mathematical precedence rules .
, Question 5
When you type text in a cell, the text will appear to continue to the __________ as
far as it can until there is another cell that contains data.
A) Left
B) Right
C) Down
D) Up
Answer: B) Right
Rationale: Text entered into a cell will continue to the right as far as possible, until
it reaches a cell that contains data .
Question 6
An Excel worksheet has more than 16,000 columns and over how many rows?
A) 1 million
B) 500,000
C) 100,000
D) 1 billion
Answer: A) 1 million
Rationale: Excel worksheets contain over 16,000 columns and over 1 million rows
(specifically 1,048,576 rows) .
Proficiency Examination –
Official Software Proficiency
Certification Board
Exam Overview
The SIMNET Excel Proficiency Examination evaluates students' skills in Microsoft
Excel through performance-based simulations and multiple-choice questions . The
platform offers a progression of digital credentials from White Belt (Level 1) through
Black Belt (Level 4), with Advanced and Applied Expert credentials available .
Advanced credentials may require completing specific exams with a 90% or higher
score .
SECTION 1: ESSENTIAL SKILLS & FUNDAMENTALS
Question 1
Which of the following keystroke combinations completes a formula in Excel?
A) Shift+Enter
B) Ctrl+Enter
,C) Alt+Enter
D) Tab
Answer: B) Ctrl+Enter
Rationale: Ctrl+Enter completes a formula and keeps the active cell selected. This
is distinct from pressing Enter alone, which moves to the next cell down . The
Shift+F3 shortcut opens the Insert Function dialog box .
Question 2
Which of the following displays the result of a formula?
A) Formula bar
B) Cell
C) Name box
D) Status bar
Answer: B) Cell
Rationale: A cell displays the result of the formula, while the formula bar displays
the underlying formula itself . The Name box shows the cell address, and the Status
bar can show AutoCalculate results.
Question 3
The cell address $R$6 is an example of which type of cell reference?
A) Relative reference
B) Absolute reference
,C) Mixed reference
D) Named range
Answer: B) Absolute reference
Rationale: $R$6 is an absolute cell reference because the dollar sign
(
)𝑖𝑠𝑝𝑙𝑎𝑐𝑒𝑑𝑏𝑒𝑓𝑜𝑟𝑒𝑏𝑜𝑡ℎ𝑡ℎ𝑒𝑐𝑜𝑙𝑢𝑚𝑛𝑙𝑒𝑡𝑡𝑒𝑟𝑎𝑛𝑑𝑟𝑜𝑤𝑛𝑢𝑚𝑏𝑒𝑟. 𝑇ℎ𝑖𝑠𝑝𝑟𝑒𝑣𝑒𝑛𝑡𝑠𝑒𝑖𝑡ℎ𝑒𝑟𝑓𝑟𝑜𝑚𝑐ℎ𝑎𝑛𝑔𝑖𝑛
R6 would be mixed (absolute row, relative column), and R$6 would be mixed
(relative row, absolute column).
Question 4
Which of the following expressions equals 11?
A) 3+24
B) (3+2)4
C) 3+(2*4)
D) 3*2+4
Answer: A) 3+2*4
Rationale: According to the order of operations (PEMDAS), multiplication is
performed before addition. 24 = 8, then 3 + 8 = 11. Option B calculates (5)4 = 20,
Option C calculates 3+8 = 11 (also correct but not the best answer), and Option D
calculates 6+4 = 10. Excel follows standard mathematical precedence rules .
, Question 5
When you type text in a cell, the text will appear to continue to the __________ as
far as it can until there is another cell that contains data.
A) Left
B) Right
C) Down
D) Up
Answer: B) Right
Rationale: Text entered into a cell will continue to the right as far as possible, until
it reaches a cell that contains data .
Question 6
An Excel worksheet has more than 16,000 columns and over how many rows?
A) 1 million
B) 500,000
C) 100,000
D) 1 billion
Answer: A) 1 million
Rationale: Excel worksheets contain over 16,000 columns and over 1 million rows
(specifically 1,048,576 rows) .
