ACIS 2504 Test Questions with Correct Answers Latest Update 2025
Accounting Format - Answers -Negative numbers are surrounded in parentheses.
•The currency symbol is aligned to the left side of the cell.
•Zero values are displayed as a long dash (—) aligned at the decimal position.
•The decimal place is aligned.
Currency Format - Answers •Negative numbers can be identified with a dash (-), parentheses, or
displayed in red.
•The currency symbol is placed directly left of the value.
•Zero values are displayed as "0" with zeroes in
each decimal place.
Comma format - Answers Accounting format without a dollar sign
Relative Cell Reference - Answers Change when the formula or function is copied to another location
(=C3+D3)
Absolute Cell Reference - Answers Do not change if a formula or function is copied to another location
(=$C$3+$D$3)
Mixed Cell Reference - Answers A combination of relative and absolute cell references (=$C3+D$3)
F4 button - Answers This button can be used to change cell referencing
=ABS(Number) (Math function) - Answers Absolute Value
=INT(Number) (math function) - Answers Round down to nearest integer
=ROUND(Number, Num_Digits) (math function) - Answers Round to a specified number of digits
=AVERAGE(Number1, [Number2],...) (stat function) - Answers Returns the mean from a set of numbers
COUNT(Value1,[Value2],...) - Answers Counts the number of cells in a range that contains numbers
COUNTA(Value1,[Value 2],...) - Answers Counts the number of cells in a range that are not empty
COUNTBLANK(range) - Answers Counts the number of empty cells in a range
MEDIAN(Number1,[Number 2],...) - Answers Returns the number of empty cells in a range
MAX(Number1,[Number2],...) - Answers Returns the largest number from a set of numbers
MIN(Number1,[Number2],...) - Answers Returns the smallest number from a set of numbers
, MODE.SNGL(Number 1,[Number 2],...) - Answers Returns the value that occurs most often within a set
DATE(Year,Month,Day) - Answers Returns the number that represents the date in the microsoft excel
date-time code
DATEDIF(Date1,Date2,Interval) - Answers Returns the time unit specified between two dates, including
the two dates (inclusive)
Date 1: starting date
Date 2: ending date
Interval: D (returns the number of complete days between the dates), M, Y
DAY(Serial_Number) - Answers Returns the day of the month, a number from 1 to 12
MONTH(Serial_Number) - Answers Returns the month, a number from 1 to 12
TODAY() - Answers Returns the computer system date
HOUR(Serial_number) - Answers Returns the hour in a time value, from 0 to 23
MINUTE(Serial_Number) - Answers Returns the minute in a time value, from 0 to 59
SECOND(Serial_Number) - Answers Returns the number of seconds in a time value, from 0 to 59
NOW() - Answers Returns the computer system date and time
Text Functions - Answers Help manage, manipulate, and format text data. Also can be used to cleanse
text. Data stored as text is commonly referred to as a string
CONCATENATE(text1, text2,...) - Answers Joins text1, text2,...,textn together in order into a single string
value
FIND(find_text, within_text, [start_num]) - Answers finds find_text in within_text. The search begins at
start_num and is case sensitive. The starting position of find_text is returned. If the find_text is not
present an error will be returned
LEFT(text, [num_chars]) - Answers Returns a string num_chars long from the left side of the text,
num_chars is usually a number that represents how long you want the string to be
LEN(text) - Answers Returns a number that represents the number of characters
MID(text,start_num,num_chars) - Answers Returns a string extracted from text beginning in the position
of start_num that is num_chars long, start_num is where it starts from the left hand side and num chars
is how long it is from that start point
Accounting Format - Answers -Negative numbers are surrounded in parentheses.
•The currency symbol is aligned to the left side of the cell.
•Zero values are displayed as a long dash (—) aligned at the decimal position.
•The decimal place is aligned.
Currency Format - Answers •Negative numbers can be identified with a dash (-), parentheses, or
displayed in red.
•The currency symbol is placed directly left of the value.
•Zero values are displayed as "0" with zeroes in
each decimal place.
Comma format - Answers Accounting format without a dollar sign
Relative Cell Reference - Answers Change when the formula or function is copied to another location
(=C3+D3)
Absolute Cell Reference - Answers Do not change if a formula or function is copied to another location
(=$C$3+$D$3)
Mixed Cell Reference - Answers A combination of relative and absolute cell references (=$C3+D$3)
F4 button - Answers This button can be used to change cell referencing
=ABS(Number) (Math function) - Answers Absolute Value
=INT(Number) (math function) - Answers Round down to nearest integer
=ROUND(Number, Num_Digits) (math function) - Answers Round to a specified number of digits
=AVERAGE(Number1, [Number2],...) (stat function) - Answers Returns the mean from a set of numbers
COUNT(Value1,[Value2],...) - Answers Counts the number of cells in a range that contains numbers
COUNTA(Value1,[Value 2],...) - Answers Counts the number of cells in a range that are not empty
COUNTBLANK(range) - Answers Counts the number of empty cells in a range
MEDIAN(Number1,[Number 2],...) - Answers Returns the number of empty cells in a range
MAX(Number1,[Number2],...) - Answers Returns the largest number from a set of numbers
MIN(Number1,[Number2],...) - Answers Returns the smallest number from a set of numbers
, MODE.SNGL(Number 1,[Number 2],...) - Answers Returns the value that occurs most often within a set
DATE(Year,Month,Day) - Answers Returns the number that represents the date in the microsoft excel
date-time code
DATEDIF(Date1,Date2,Interval) - Answers Returns the time unit specified between two dates, including
the two dates (inclusive)
Date 1: starting date
Date 2: ending date
Interval: D (returns the number of complete days between the dates), M, Y
DAY(Serial_Number) - Answers Returns the day of the month, a number from 1 to 12
MONTH(Serial_Number) - Answers Returns the month, a number from 1 to 12
TODAY() - Answers Returns the computer system date
HOUR(Serial_number) - Answers Returns the hour in a time value, from 0 to 23
MINUTE(Serial_Number) - Answers Returns the minute in a time value, from 0 to 59
SECOND(Serial_Number) - Answers Returns the number of seconds in a time value, from 0 to 59
NOW() - Answers Returns the computer system date and time
Text Functions - Answers Help manage, manipulate, and format text data. Also can be used to cleanse
text. Data stored as text is commonly referred to as a string
CONCATENATE(text1, text2,...) - Answers Joins text1, text2,...,textn together in order into a single string
value
FIND(find_text, within_text, [start_num]) - Answers finds find_text in within_text. The search begins at
start_num and is case sensitive. The starting position of find_text is returned. If the find_text is not
present an error will be returned
LEFT(text, [num_chars]) - Answers Returns a string num_chars long from the left side of the text,
num_chars is usually a number that represents how long you want the string to be
LEN(text) - Answers Returns a number that represents the number of characters
MID(text,start_num,num_chars) - Answers Returns a string extracted from text beginning in the position
of start_num that is num_chars long, start_num is where it starts from the left hand side and num chars
is how long it is from that start point
