{"id":4123,"date":"2023-06-12T00:00:00","date_gmt":"2023-06-11T15:00:00","guid":{"rendered":"https:\/\/pasocollege.com\/book\/?page_id=4123"},"modified":"2023-12-20T13:38:19","modified_gmt":"2023-12-20T04:38:19","slug":"excel_jokyu02_jyokentsukishoshiki","status":"publish","type":"page","link":"https:\/\/pasocollege.com\/book\/titles\/excel_jokyu02_jyokentsukishoshiki\/","title":{"rendered":"\u30a8\u30af\u30bb\u30eb\u4e0a\u7d1a2\u7ae0\u3000\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u306e\u9054\u4eba"},"content":{"rendered":"
\n
\"\"<\/figure>\n<\/div>\n\n\n

\u672c\u30c6\u30ad\u30b9\u30c8\u3067\u306f\u3001Excel\u306e\u4fbf\u5229\u306a\u6a5f\u80fd\u300c\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u300d\u306b\u3064\u3044\u3066\u5b66\u3073\u307e\u3059\u3002<\/p>\n\n\n\n

\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3068\u306f\u3001\u6570\u5024\u306e\u5927\u5c0f\u3084\u6587\u5b57\u5217\u306e\u6709\u7121\u3001\u6570\u5f0f\u3092\u7528\u3044\u305f\u6761\u4ef6\u3092\u8a2d\u5b9a\u3057\u3001\u305d\u308c\u306b\u3088\u3063\u3066\u6587\u5b57\u3084\u30bb\u30eb\u306e\u66f8\u5f0f\u306e\u30aa\u30f3\/\u30aa\u30d5\u3092\u5207\u308a\u66ff\u3048\u3089\u308c\u308b\u6a5f\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n

\u300c\u4ee5\u4e0a\u300d\u300c\u4ee5\u4e0b\u300d\u3092\u5229\u7528\u3057\u305f\u7c21\u5358\u306a\u6570\u5f0f\u3092\u6761\u4ef6\u306b\u3059\u308b\u3001\u521d\u6b69\u7684\u306a\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u304b\u3089\u3001\u8907\u6570\u306e\u6570\u5f0f\u3092\u4f7f\u3063\u305f\u3082\u306e\u3084\u3001\u95a2\u6570\u3092\u5229\u7528\u3057\u305f\u5fdc\u7528\u307e\u3067\u7406\u89e3\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u3087\u3046\u3002\u4f5c\u696d\u3092\u52b9\u7387\u3088\u304f\u9032\u3081\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

\u300c\u81ea\u52d5\u7684\u306b\u66f8\u5f0f\u3092\u5909\u66f4\u3057\u3066\u898b\u3084\u3059\u304f\u3057\u305f\u3044\u300d\u300c\u30a8\u30af\u30bb\u30eb\u3067\u30bf\u30b9\u30af\u3092\u7ba1\u7406\u3057\u305f\u3044\u300d\u3068\u3044\u3046\u4eba\u306b\u30aa\u30b9\u30b9\u30e1\u306e\u4e00\u518a\u3067\u3059\u3002\u307e\u305f\u3001\u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u3092\u5370\u5237\u3059\u308b\u969b\u306e\u30c6\u30af\u30cb\u30c3\u30af\u3082\u4ed8\u9332\u3067\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002\u300c\u3088\u308a\u30b9\u30de\u30fc\u30c8\u306b\u4f5c\u696d\u3059\u308b\u65b9\u6cd5\u3092\u300d\u300c\u5c11\u3057\u3067\u3082\u4f5c\u696d\u52b9\u7387\u7684\u306b\u9032\u3081\u305f\u3044\u300d\u3068\u3044\u3046\u4eba\u306b\u30aa\u30b9\u30b9\u30e1\u306e\u5185\u5bb9\u3067\u3059\u3002<\/p>\n\n\n\n

\u3054\u8cfc\u5165\u60c5\u5831<\/h3>\n\n\n\n
\u63a8\u5968\u5b66\u7fd2\u6642\u9593<\/td>1\u6642\u9593<\/td><\/tr>
\u30da\u30fc\u30b8\u6570<\/td>58\u30da\u30fc\u30b8\uff08\u5168\u7ae0\u7dcf\u8a08\uff09<\/td><\/tr>
\u4f53\u88c1<\/td>A4\u30b5\u30a4\u30ba<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u5185\u5bb9<\/h2>\n\n\n\n

<\/p>\n\n\n\n

    \n
  • \u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u306e\u6982\u8981<\/li>\n\n\n\n
  • \u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n\n\n\n
  • \u8907\u6570\u306e\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n\n\n\n
  • \u6570\u5f0f\u3092\u4f7f\u3063\u305f\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n\n\n\n
  • \u8907\u6570\u306e\u6761\u4ef6\u306e\u53cd\u6620\u3055\u308c\u308b\u9806\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n\n\n\n
  • \u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u89e3\u9664\u3059\u308b<\/li>\n\n\n\n
  • \u5e73\u5747\u5024\u3092\u6761\u4ef6\u306b\u3059\u308b(AVERAGE\u95a2\u6570)<\/li>\n\n\n\n
  • \u30bb\u30eb\u304c\u7a7a\u767d\u3067\u3042\u308b\u3053\u3068\u3092\u6761\u4ef6\u306b\u3059\u308b<\/li>\n\n\n\n
  • \u30bb\u30eb\u304c\u7a7a\u767d\u3067\u306a\u3044\u3053\u3068\u3092\u6761\u4ef6\u306b\u3059\u308b<\/li>\n\n\n\n
  • \u7279\u5b9a\u306e\u6587\u5b57\u5217\u3092\u6761\u4ef6\u306b\u3059\u308b<\/li>\n\n\n\n
  • \u6587\u5b57\u6570\u3092\u6761\u4ef6\u306b\u3059\u308b\uff08LEN\u95a2\u6570\uff09<\/li>\n\n\n\n
  • \u300c\u307e\u305f\u306f\u300d\u306e\u6761\u4ef6\u3092\u8a2d\u5b9a\u3059\u308b\uff08OR\u95a2\u6570\uff09<\/li>\n\n\n\n
  • \u7a7a\u767d\u3067\u306f\u306a\u3044\u30bb\u30eb\u3092\u6761\u4ef6\u306b\u3059\u308b<\/li>\n\n\n\n
  • \u7279\u5b9a\u306e\u6587\u5b57\u5217\u3092\u30bb\u30eb\u53c2\u7167\u3067\u6761\u4ef6\u306b\u3059\u308b<\/li>\n\n\n\n
  • \u65e5\u4ed8\u306e\u30c7\u30fc\u30bf\u3092\u65e5\u306b\u3061\u3060\u3051\u306e\u8868\u793a\u306b\u3059\u308b<\/li>\n\n\n\n
  • \u6708\u3092\u5165\u529b\u3059\u308b\uff08MONTH\u95a2\u6570\uff09<\/li>\n\n\n\n
  • \u66dc\u65e5\u3092\u5165\u529b\u3059\u308b\uff08TEXT\u95a2\u6570\uff09<\/li>\n\n\n\n
  • \u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3067\u6587\u5b57\u3092\u975e\u8868\u793a\u306b\u3059\u308b<\/li>\n\n\n\n
  • \u5217\u5e45\u306b\u5408\u308f\u305b\u3066\u6587\u5b57\u3092\u8abf\u6574\u3059\u308b<\/li>\n\n\n\n
  • \u5165\u529b\u898f\u5247\u3067\u9032\u6357\u72b6\u6cc1\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n\n\n\n
  • \u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3067\u7279\u5b9a\u306e\u66dc\u65e5\u306e\u8272\u3092\u5909\u3048\u308b<\/li>\n\n\n\n
  • \u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u306e\u30eb\u30fc\u30eb\u3092\u4fee\u6b63\u3059\u308b<\/li>\n<\/ul>\n\n\n","protected":false},"excerpt":{"rendered":"

    Excel\u306e\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u5fb9\u5e95\u7684\u306b\u5b66\u3076\u30c6\u30ad\u30b9\u30c8\u3067\u3059\u3002\u6570\u5024\u30fb\u6587\u5b57\u5217\u30fb\u6570\u5f0f\u3092\u6761\u4ef6\u306b\u3057\u305f\u66f8\u5f0f\u8a2d\u5b9a\u304b\u3089\u95a2\u6570\u3092\u4f7f\u3063\u305f\u5fdc\u7528\u307e\u3067\u7fd2\u5f97\u3067\u304d\u307e\u3059\u3002\u30bf\u30b9\u30af\u7ba1\u7406\u3084\u898b\u3084\u3059\u3044\u8868\u4f5c\u6210\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n","protected":false},"author":11,"featured_media":4302,"parent":1514,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","vkExUnit_sitemap":"","_veu_custom_css":"","veu_display_promotion_alert":"common","_exclude_from_list_pages":"","vkexunit_cta_each_option":"","vkExUnit_childPageIndex":"","vkExUnit_pageList_ancestor":"","vkExUnit_contact_enable":"","_lightning_design_setting":{"layout":"default","header_trans":"default","section_base":"default"},"header_top_description":"","vk_page_header_image":0,"vk_page_header_image_sp":0,"vk_page_header_subtext":"","footnotes":""},"categories":[26,99,37],"tags":[],"class_list":["post-4123","page","type-page","status-publish","has-post-thumbnail","hentry","category-excel","category-text","category-practical"],"aioseo_notices":[],"veu_head_title_object":{"title":"","add_site_title":""},"_links":{"self":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/4123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/comments?post=4123"}],"version-history":[{"count":10,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/4123\/revisions"}],"predecessor-version":[{"id":4575,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/4123\/revisions\/4575"}],"up":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/1514"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/media\/4302"}],"wp:attachment":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/media?parent=4123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/categories?post=4123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/tags?post=4123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}