EXCEL CRASH COURSE EXAM 259 PRACTICE TEST 2026 QUESTIONS WITH CORRECT ANSWERS

EXCEL CRASH COURSE EXAM 259 PRACTICE
TEST 2026 QUESTIONS WITH CORRECT
ANSWERS

◉ Trace precedents. Answer: Alt + M + P


◉ Trace dependents. Answer: Alt + M + D


◉ Remove arrows. Answer: Alt + M + A


◉ How to format inputs/hardcodes blue. Answer: Go to special (Ctrl
+ G), then Custom, select Constants and format text blue


◉ Go to special. Answer: Ctrl + G


◉ Conditional formatting. Answer: Alt + O + D or Alt + H + L


◉ Custom formatting formula syntax. Answer: [positive number
format; negative number format, 0 format]


◉ How to out text after a number in custom formatting. Answer: Use
quote marks

, ◉ How to align positive numbers with negative numbers in custom
formats. Answer: Put a ) after the positive number format, it will
appear as a space


◉ Zoom in and out. Answer: Ctrl + Alt + +/-


◉ In custom formatting, what should you use instead of 0s to ensure
commas only appear in the thousands. Answer: #


◉ What function is the same as EOMONTH but for a specific date?.
Answer: EDATE


◉ How to output different things depending on if there's text or
numbers in a cell. Answer: IF + ISTEXT functions


◉ Function to turn things into a date. Answer: DATE


◉ When to use HLOOKUP. Answer: When your comparison values
are all in a row across the top of the data table, and you want to look
down a specified number of rows